package br.uneb.tebd.util;

public class Constants {
	
	public static String QUERY_ALL_GUITARS = "SELECT * FROM GUITAR";
	
	public static String QUERY_SELECT_BY_DESCRIPTION = "SELECT * FROM GUITAR WHERE DESCRIPTION LIKE ?";
	
	public static String QUERY_SELECT_BY_ID = "SELECT * FROM GUITAR WHERE ID = ?";
	
	public static String QUERY_INSERT_GUITAR = "INSERT INTO GUITAR (DESCRIPTION, MODEL, BRAND) VALUES(?,?,?)";
	
	public static String QUERY_UPDATE_GUITAR = "UPDATE GUITAR SET DESCRIPTION = ?, MODEL = ?, BRAND = ? WHERE ID = ?";
	
	public static String QUERY_DELETE_BY_ID = "DELETE FROM GUITAR WHERE ID = ?";

	public static String QUERY_DELETE_BY_DESCRIPTION = "DELETE FROM GUITAR WHERE DESCRIPTION LIKE ?";
	
	
	public static String MSG_GUITAR_NOT_FOUND = "Guitar inexistente.";
	
	public static String MSG_GUITAR_FOUND = "A Guitar ja foi inserida.";

	public static String MSG_GUITAR_REMOVED = "Guitar removida com sucesso!";
	
	public static String MSG_GUITAR_UPDATED = "Guitar atualizada com sucesso!";
	
	public static String MSG_GUITAR_INSERTED = "Guitar inserida com sucesso!";
}
